%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%  RECUPERATION DONNEES  %%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
\subsection{Récupération des données du NCBI}
  \begin{frame}
    \frametitle{Construction de la base de données}
    Objectif :
    \begin{itemize}
      \item Récupérer les données génétiques d’un sous-arbre de l’arbre phylogénétique du NCBI
    \end{itemize}
    \pause
    Pourquoi :
    \begin{itemize}
      \item Effectuer la classification de l'étape suivante du projet
    \end{itemize}
    \pause
    Comment :
    \begin{itemize}
      \item Requêter la base de donnée du NCBI
    \end{itemize}
  \end{frame}
  %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
  \begin{frame}
    \frametitle{Récupérer les données génétiques}
    \begin{center}
      \includegraphics[scale=0.40]{../../imports/constructionBDDR.png} 
    \end{center}
  \end{frame}
  %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
  \begin{frame}
    \frametitle{Fichier genbank}
    Que contient le fichier genbank ?\\
    \begin{itemize}
      \item Toutes les données génétiques des descendants du taxon sur lequel on effectue la requête
    \end{itemize}
    \begin{center}
      \begin{tabular}{ | l | l | }
        \hline
        Partie & Informations données \\ \hline
        ORIGIN & Séquence d'ADN complète \\ \hline
        FEATURES & Informations importantes \\ \hline
        Informations sur l'espèce & nom, numéro d'accession, ... \\
        \hline
      \end{tabular}
    \end{center}
  \end{frame}
  %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
  \begin{frame}
    \frametitle{Effectuer les requêtes sur le NCBI}
    Initialisation du module \textit{EUtilities} du langage Perl
    \begin{center}
      \includegraphics[scale=0.40]{../../imports/requeteNCBIS.png} 
    \end{center}
  \end{frame}
  %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
  \begin{frame}
    \frametitle{Exemple de requête}
      \begin{itemize}
        \item Requête permettant d'obtenir tous les génomes complets des mitochondries du taxon d'identifiant A
      \end{itemize}
      \begin{center}
        \includegraphics[scale=0.35]{../../imports/requeteNCBIS2.png}
      \end{center}
  \end{frame}
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%  CONSTRUCTION BDD  %%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
\subsection{Construction de la base de données locale}
  \begin{frame}
    \frametitle{Structure arborescence locale}
    \begin{itemize}
      \item Création d'un dossier si un génome contient plus de S fils (avec S entier positif)
    \end{itemize}
    \begin{center}
        \includegraphics[scale=0.35]{../../imports/ncbiSNB.png}
    \end{center}
  \end{frame}
     %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
  \begin{frame}
    \frametitle{Exemple concret de la règle de construction}
    Pour un seuil S égal à 6 :
    \begin{columns}
        \begin{column}{0.6\textwidth}
            \begin{center}
                \includegraphics<1>[scale=0.35]{../../imports/ncbiSNB.png}
                \vfill
            \end{center}
        \end{column}
        \begin{column}{0.4\textwidth}      
            \begin{center}
                \includegraphics<1>[scale=0.40]{../../imports/dossierS.png}
                \vfill
            \end{center}
        \end{column}
    \end{columns}
  \end{frame}
    %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
  \begin{frame}
    \frametitle{Génération des dossiers}
    \begin{itemize}
      \item Besoin : connaître le nombre de génomes de chaque taxon
    \end{itemize}
    \begin{columns}
        \begin{column}{0.5\textwidth}
            \begin{center}
                \includegraphics[scale=0.40]{../../imports/comptageSGenomes1.png}
            \end{center}
        \end{column}
        \begin{column}{0.5\textwidth}      
        \end{column}
    \end{columns}
  \end{frame}
  %%%%%%%%%%%%
  \begin{frame}
    \frametitle{Génération des dossiers}
    \begin{itemize}
      \item Besoin : connaître le nombre de génomes de chaque taxon
    \end{itemize}
    \begin{columns}
        \begin{column}{0.5\textwidth}
            \begin{center}
                \includegraphics[scale=0.40]{../../imports/comptageSGenomes1.png}
            \end{center}
        \end{column}
        \begin{column}{0.5\textwidth} 
            \begin{center} 
                \includegraphics[scale=0.40]{../../imports/comptageSGenomes2.png}
            \end{center}    
        \end{column}
    \end{columns}
  \end{frame}
    %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
  
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%  GESTION DONNEES  %%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
\subsection{Gestion des données}
  \begin{frame}
    \frametitle{Gestion des données}
    \begin{itemize}
      \item Fichier au format fasta : regroupe les informations importantes de chaque taxon présent dans le dossier
      \item Contient :
      \begin{itemize}
        \item les protéines et la séquence codante
        \item Le nom des protéines
        \item Le nom de l'espèce dans laquelle nous avons trouvé cette protéine.
      \end{itemize}
    \end{itemize}
  \end{frame}
  
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%  PROBLEMES RENCONTRES  %%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%  \begin{frame}
%    \frametitle{Problèmes rencontrés}
%    Lors de cette première phase, nous avons rencontrés plusieurs problèmes :
%  \end{frame}   
